#!/usr/bin/python
# -*- coding: utf-8 -*-
# @author: 高建平
# @description: 
#

from sqlalchemy import Column, Integer, String, DateTime, func, Date
from app.providers.database_provider import Base
from app.support.decorator import decorator_str


@decorator_str
class ProjectSaleStrategyPo(Base):
    __tablename__ = "project_sale_strategy"
    id = Column(Integer, primary_key=True, autoincrement=True)
    # 子项目
    sub_project_code = Column(String)
    # 销售策略code
    sale_strategy_code = Column(Integer)
    # 大区编号
    region_code = Column(String)
    # 事业部编号
    division_code = Column(String)
    # 对接日期
    docking_date = Column(Date)
    # 开始日期
    start_date = Column(Date)
    # 结束日期
    end_date = Column(Date)
    # 销售政策文件
    sale_policy_doc_ids = Column(String)
    # 首发结果
    first_launch_status = Column(Integer)
    # 首发成功日期
    first_launch_success_date = Column(Date)
    # 备注
    remark = Column(String)
    # 状态 0: 否；1: 是
    snapshot = Column(Integer)
    # 创建者ID
    create_user_id = Column(String)
    # 创建者名字
    create_user_name = Column(String)
    # 创建时间
    create_time = Column(DateTime)
    # 更新者ID
    update_user_id = Column(String)
    # 更新者名字
    update_user_name = Column(String)
    # 更新时间
    update_time = Column(DateTime)
    
    class Config:
        orm_mode = True